var express = require('express');
var router = express.Router();
const db = require('../db/connect');
const jwt = require('jsonwebtoken');
const { json } = require('express');
var http = require("http");
router.get('/', function(req, res, next) {
	// res.send(result);
	res.render('wklogin.ejs');
});
router.get('/my.ejs', function(req, res, next) {
	res.render('my.ejs',{cookies:'cookies'});
});
router.get('/wkreg.ejs', function(req, res, next) {
	res.render('wkreg.ejs',{cookies:'cookies'});
});
// 注册
router.get('/reg/reg', function(req, res, next) {
	    const {user,tel,pwd,sex} = req.query;
		
	    // console.log(user,tel,pwd,sex,"xxxxxxxxxxxxxxxxxxxxx")
		db.query('INSERT INTO user_list (name,tel,sex,pwd) values (?,?,?,?) ', [user,tel,pwd,sex]
		, function(result, fields) {
			res.send({
			code:1,
			msg:"操作成功"
			})
		});
});
router.get('/find/find', function(req, res, next) {
	// res.header("Access-Control-Allow-Origin", "*");
  // res.header("Access-Control-Allow-Headers", "X-Requested-With");
  // res.header("Access-Control-Allow-Methods","PUT,POST,GET,DELETE,OPTIONS");
  // res.header("X-Powered-By",' 3.2.1')
  // res.header("Content-Type", "application/json;charset=utf-8");
  console.log(req,'////////////////////');
	res.send({
		"total":28,"rows":
		[
			{"productid":"FI-SW-01","productname":"Koi","unitcost":"10.00","status":"P","listprice":"36.50","attr1":"Large","itemid":"EST-1"},
			{"productid":"K9-DL-01","productname":"Dalmation","unitcost":"12.00","status":"P","listprice":"18.50","attr1":"Spotted Adult Female","itemid":"EST-10"},
			{"productid":"RP-SN-01","productname":"Rattlesnake","unitcost":"12.00","status":"P","listprice":"38.50","attr1":"Venomless","itemid":"EST-11"},
			{"productid":"RP-SN-01","productname":"Rattlesnake","unitcost":"12.00","status":"P","listprice":"26.50","attr1":"Rattleless","itemid":"EST-12"},
			{"productid":"RP-LI-02","productname":"Iguana","unitcost":"12.00","status":"P","listprice":"35.50","attr1":"Green Adult","itemid":"EST-13"},
			{"productid":"FL-DSH-01","productname":"Manx","unitcost":"12.00","status":"P","listprice":"158.50","attr1":"Tailless","itemid":"EST-14"},
			{"productid":"FL-DSH-01","productname":"Manx","unitcost":"12.00","status":"P","listprice":"83.50","attr1":"With tail","itemid":"EST-15"},
			{"productid":"FL-DLH-02","productname":"Persian","unitcost":"12.00","status":"P","listprice":"23.50","attr1":"Adult Female","itemid":"EST-16"},
			{"productid":"FL-DLH-02","productname":"Persian","unitcost":"12.00","status":"P","listprice":"89.50","attr1":"Adult Male","itemid":"EST-17"},
			{"productid":"AV-CB-01","productname":"Amazon Parrot","unitcost":"92.00","status":"P","listprice":"63.50","attr1":"Adult Male","itemid":"EST-18"}
		]}
		
	)
})
// 登陆
router.get('/login/login',function(req,res) {
	res.setHeader('Content-Type', 'text/html; charset=utf-8')
	var tel = req.query.tel;
	var pwd = req.query.pwd;

	db.query('SELECT * FROM user_list where tel=?',[tel],
	function(result, fields) {
		// console.log(result);
		if(result.length==1){
			var token = jwt.sign({ tel,pwd}, 'YXFXM'); 
			let obj = { code:200,
				msg:'登陆成功',
				data:{'token':token}
			}
			// res.cookie('tel',encodeURI(tel),{maxAge:60000,path:'/',httpOnly:true});
			res.end( JSON.stringify(obj))
			return false
		}
		res.end(JSON.stringify({ code:200,
			msg:'失败',
		}))
		
	});
		
})


module.exports = router;
